using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace DDSolutionBE

{

    public class ViewBankExceptionsBE

    {

        public int MasterDataID { get; set; }

        public string ParticipantID { get; set; }

        public string GroupNumber { get; set; }

        public DateTime TransactionDate { get; set; }

        public string CustFirstName { get; set; }

        public string CustLastName { get; set; }

       // public string CustomerName { get; set; }

        public string AccountNumber { get; set; }

        public string ExceptionType { get; set; }

        public string ErrorCode { get; set; }

        public string ErrorDescription { get; set; }

        public string BankName { get; set; }

        public int FileId { get; set; }

        public double Amount { get; set; }

        public int TotalRecords { get; set; }

        public string FileName { get; set; }

        public string FileType { get; set; }

        public DateTime FileGenerationDateTime { get; set; }

        public DateTime FileGenerationEndDateTime { get; set; }

        public string FilePath { get; set; }

        public bool isActive { get; set; }

        public DateTime CreatedDateTime { get; set; }

        public int UserID { get; set; }

        public int ParentFileID { get; set; }

        public string MasterData { get; set; }

        public string Date { get; set; }

        public string Adress1 { get; set; }

        public string Adress2 { get; set; }

        public string Adress3 { get; set; }

        public string PostalCode { get; set; }

        public string Parish { get; set; }

        public string GrpName { get; set; }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionDALC;

using DDSolutionBE;

namespace DDSolutionBO

{

    public class ViewBankExceptionsBO

    {

        PolicyholderDAL dalPH = new PolicyholderDAL();

        ViewBankExceptionsDAL vbedal = new ViewBankExceptionsDAL();

        public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminx(string strFname, stringstrLname, string strMInit, string strParticID, string strGrpID)

        {

            try

            {

                return dalPH.GetPolicyholdersFromLuminx(strFname, strLname, strMInit, strParticID, strGrpID);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public IEnumerable<LuminXParticipantsBE> GetPolicyholdersFromLuminxByGroup(string strGrpID, stringstrGrName)

        {

            try

            {

                return dalPH.GetPolicyholdersFromLuminxByGroup(strGrpID, strGrName);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public DataTable GetAllDDExceptionRecords(string BankName,string PHolder,string FromDate,stringToDate)

        {

            try

            {

                return vbedal.GetAllDDExceptionRecords(BankName, PHolder,FromDate, ToDate);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public IEnumerable<ViewBankExceptionsBE> GetExceptionByParticpants(string strBankName, stringstrFromDate, string strToDate)

        {

            return vbedal.GetExceptionByParticpants(strBankName, strFromDate, strToDate);

        }

        public IEnumerable<ViewBankExceptionsBE> GetExceptionByGroup(string strBankName, string strFromDate,string strToDate)

        {

            return vbedal.GetExceptionByGroup(strBankName, strFromDate, strToDate);

        }

        public DataTable CheckFileGeneration(string IndorGrp)

        {

            return vbedal.CheckFileGeneration(IndorGrp);

        }

        public IEnumerable<ViewBankExceptionsBE> GetExceptionsFileType()

        {

            try

            {

                return vbedal.GetExceptionsFileType();

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public String InsertintoLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

        {

            try

            {

                return vbedal.InsertintoLuminXPaymentPostingHeader(vbebe);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public String InsertintoLuminXPaymentPostingDetails(ViewBankExceptionsBE vbebe)

        {

            try

            {

                return vbedal.InsertintoLuminXPaymentPostingDetails(vbebe);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public String UpdateLuminXPaymentPostingHeader(ViewBankExceptionsBE vbebe)

        {

            try

            {

                return vbedal.UpdateLuminXPaymentPostingHeader(vbebe);

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public void DeleteEntry(ViewBankExceptionsBE vbebe)

        {

            try

            {

                vbedal.DeleteEntry(vbebe);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

    }

}

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

using System.Text;

using System.Data;

using DDSolutionBE;

namespace DDSolutionDALC

{

    public class ViewDDExceptionsDAL

    {

        DDSolutionClassDataContext context = new DDSolutionClassDataContext();

        GeneralDAL gnl = new GeneralDAL();

        LoadOPPFileBE lopbe = new LoadOPPFileBE();

        public DataTable GetDDExcepRecords(string FundType,string Fromdate, string Todate)

        {

            try

            {

                var Records = context.usp_GetACHExceptionsByDate(FundType, Fromdate, Todate);

                return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

        public DataTable GetDDAS400ExcepRecords(string Fundtype, string Fromdate, string Todate)

        {

            try

            {

                var Records = context.usp_GetDDAS400ExcepionsByDate(Fundtype, Fromdate, Todate);

                return gnl.ObtainDataTableFromIEnumerable(Records); // collection;

            }

            catch (Exception ex)

            {

                throw new Exception(ex.Message);

            }

        }

    }

}

using System;

using System.Collections.Generic;

using System.Globalization;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using DDSolutionBO;

using DDSolutionBE;

using System.Text;

using DDSolutionDALC;

using System.Configuration;

using System.IO;

public partial class UI_BankExceptionManagement : System.Web.UI.Page

{

    PolicyholderBO boPH = new PolicyholderBO();

    General gnl = new General();

    DataTable dtMailingAddress = new DataTable();

    DataTable dtGetdata = new DataTable();

    ViewBankExceptionsBO vbebo = new ViewBankExceptionsBO();

    ViewBankExceptionsBE vbebe = new ViewBankExceptionsBE();

    string FilePath = "";

    string fileDate = "";

    string FilType = "";

    int ParentID;

    string rtnmsg = "";

    int UserID;

    string GeneratedFileId;

    DateTime FilegeneratedDateTime;

    double TotalAmt = 0.00;

    int Recordcount;

    string strFileName = "";

    protected void Page_Load(object sender, EventArgs e)

    {

        // To Clear Cache

        Response.Buffer = true;

        Response.ExpiresAbsolute = DateTime.Now;

        Response.CacheControl = "no-cache";

        // To Clear Cache

        //CE3.SelectedDate = DateTime.Today;

        //CE4.SelectedDate = DateTime.Today;

        try

        {

            if (Request.Cookies["UserInfo"] == null) Response.Redirect("Login.aspx");

            if (!IsPostBack)

            {

                //txtFromDate.Text = gnl.GetASTDate().ToShortDateString();

                //txtToDate.Text = gnl.GetASTDate().ToShortDateString();

                //BindExceptions();

            }

            if(Request.Cookies["UserInfo"].Values["RoleName"].ToString().ToUpper().Trim().Contains("VIEWER"))

            {

                btnGenerateLetter.Enabled = false;

            }

            UserID = Convert.ToInt32(Request.Cookies["UserInfo"]["UserId"]);

        }

        catch (Exception ex)

        {

            errMsg.Attributes["class"] = "MsgBox error";

            errMsg.InnerHtml = ex.Message;

        }

    }

    protected void btnClose_Click(object sender, EventArgs e)

    {

        Response.Redirect("../UI/MainPage.aspx");

    }

    private void GenerateINDLetter()

    {

        try

        {

            StringBuilder sb = new StringBuilder();

            IEnumerable<ViewBankExceptionsBE> ieGetExcepByParticip;

            ieGetExcepByParticip = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

            //dtGetdata = vbebo.GetExceptionByParticpants(ddlBankName.SelectedItem.Text, txtFromDate.Text, txtToDate.Text);

            if (ieGetExcepByParticip.Count() > 0)

            //if (dtGetdata.Rows.Count > 0)

            {

                Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

                fileDate = gnl.GenerateFileName("");//.GetASTDate().ToString("MMddyyyy_HHmmss");// Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

                FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

                strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

                InsertintoLuminXPaymentPostingHeader();

                foreach (var item in ieGetExcepByParticip)

                {

                    //vbebe.ParticipantID = drow[0].ToString();

                    //vbebe.GroupNumber = drow[1].ToString();

                    //vbebe.TransactionDate = Convert.ToDateTime(drow[2].ToString());

                    //vbebe.CustFirstName = drow[3].ToString();

                    //vbebe.CustLastName = drow[4].ToString();

                    //CustomerName = vbebe.CustFirstName + " " + vbebe.CustLastName;

                    //vbebe.AccountNumber = drow[5].ToString();

                    //vbebe.ErrorDescription = drow[6].ToString();

                    //TransactionDate1 = vbebe.TransactionDate;

                    //IEnumerable<LuminXParticipantsBE> ieLxParticips = null;

                    //ieLxParticips = vbebo.GetPolicyholdersFromLuminx(null, null, null, vbebe.ParticipantID, vbebe.GroupNumber);

                    //foreach (var item in ieLxParticips)

                    //{

                    //string str = item.MailingAddress;

                    //string[] words = str.Split('%');

                    //string Address1 = words[0].ToString();

                    //string Addressstr = words[1].ToString();

                    ////string[] Addressstr2 = Addressstr.Split(',');

                    ////string Address2 = Addressstr2[0].ToString();

                    ////string Address3 = Addressstr2[1].ToString();

                    //// string Address4 = Addressstr2[2].ToString();

                    //string mainstr = null;

                    //string[] splitstr = Addressstr.Split(new Char[] { ',' });

                    //foreach (string line in splitstr)

                    //{

                    //    //array for the measurement

                    //    // string[] measurementArray = line.

                    //    mainstr = mainstr + line;

                    //    mainstr = mainstr + " ";

                    //}

                    sb.Append(item.Date.ToString().PadRight(10) + "|");

                    sb.Append(item.CustFirstName.ToString().PadRight(15) + "|");

                    sb.Append(item.CustLastName.ToString().PadRight(15) + "|");

                    sb.Append(item.Adress1.ToString().PadRight(25) + "|");

                    sb.Append(item.Adress2.ToString().PadRight(25) + "|");

                    sb.Append(item.Adress3.ToString().PadRight(25) + "|");

                    sb.Append(item.PostalCode.ToString().PadRight(9) + "|");

                    sb.Append(item.AccountNumber.ToString().PadRight(6) + "|");

                    sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

                    sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

                    vbebe.ParticipantID = item.ParticipantID.ToString();

                    vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

                    vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

                    vbebe.FileGenerationDateTime = FilegeneratedDateTime;

                    vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

                    vbebe.UserID = UserID;

                    vbebe.FileId = Convert.ToInt32(GeneratedFileId);

                    vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

                    TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

                    Recordcount++;

                    //sb.Append(vbebe.TransactionDate.ToString("MM-dd-yyyy").ToString().PadRight(10) + '|');

                    //sb.Append(CustomerName.ToString().PadRight(50) + '|');

                    //sb.Append(Address1.ToString().PadRight(50) + '|');

                    //sb.Append(mainstr.ToString().PadRight(100) + '|');

                    //// sb.Append(Address2.ToString().PadRight(15));

                    ////sb.Append(Address3.ToString().PadRight(15));

                    //// sb.Append(Address4.ToString().PadRight(15) + '|');

                    //sb.Append(vbebe.AccountNumber.ToString().PadRight(20) + '|');

                    //sb.Append(vbebe.ErrorDescription.ToString().PadRight(250) + '|');

                    //sb.Append(TransactionDate1.ToString("dd-MMM-yyyy").ToString().PadRight(11));//.ToString("dd-MMM-yy");

                    sb.AppendLine();

                    //}

                }

                using (StreamWriter wtr = File.CreateText(FilePath))

                {

                    UpdateDtls();

                    wtr.Write(sb.ToString());

                    //ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('File Generated Successfully');", true);

                    errMsg.Attributes["class"] = "MsgBox success";

                    errMsg.InnerHtml = "File generated successfully. Please check LetterFeedFiles folder.";

                }

            }

            else

            {

                //ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('Please Select Policyholder');", true);

                errMsg.Attributes["class"] = "MsgBox warning";

                errMsg.InnerHtml = " No records were found for given transaction date range";

                //ddlPholder.Focus();

                return;

            }

        }

        catch (Exception ex)

        {

            DeleteEntry();

            throw new Exception(ex.Message);

        }

    }

    protected void btnGenerateLetter_Click(object sender, EventArgs e)

    {

        errMsg.Attributes["class"] = "";

        errMsg.InnerHtml = "";

        try

        {

            if (ddlPholder.SelectedValue == "Individual")

                GenerateINDLetter();

            else

                GenerateGRPLetter();

        }

        catch (Exception ex)

        {

            //throw new Exception(ex.Message);

            errMsg.Attributes["class"] = "MsgBox error";

            errMsg.InnerHtml = ex.Message;

            if (File.Exists(FilePath))

            {

                File.Delete(FilePath);

            }

        }

    }

    private void GenerateGRPLetter()

    {

        try

        {

            StringBuilder sb = new StringBuilder();

            IEnumerable<ViewBankExceptionsBE> ieGetExcepByGRP;

            ieGetExcepByGRP = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

            //dtGetdata = vbebo.GetExceptionByGroup(ddlBankName.SelectedItem.ToString(), txtFromDate.Text, txtToDate.Text);

            if (ieGetExcepByGRP.Count() > 0)

            {

                Append.FileName = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

                fileDate = gnl.GenerateFileName(""); //gnl.GetASTDate().ToString("MMddyyyy_HHmmss"); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime()).ToString("MMddyyyy_HHmmss");

                FilePath = Append.FileName + "_" + ddlPholder.SelectedValue + fileDate + ".txt";

                strFileName = FilePath.Substring(FilePath.LastIndexOf('\\'), (FilePath.Length - FilePath.LastIndexOf('\\'))).Replace("\\", "");

                InsertintoLuminXPaymentPostingHeader();

                foreach (var item in ieGetExcepByGRP)

                {

                    sb.Append(item.Date.ToString().PadRight(10) + "|");

                    sb.Append(item.GrpName.ToString().PadRight(30) + "|");

                    sb.Append(item.Adress1.ToString().PadRight(25) + "|");

                    sb.Append(item.Adress2.ToString().PadRight(25) + "|");

                    sb.Append(item.Parish.ToString().PadRight(20) + "|");

                    sb.Append(item.PostalCode.ToString().PadRight(10) + "|");

                    sb.Append(item.GroupNumber.ToString().PadLeft(5, '0') + "|");

                    sb.Append(item.ErrorDescription.ToString().PadRight(20) + "|");

                    sb.Append(item.TransactionDate.ToString("dd-MMM-yyyy"));

                    vbebe.ParticipantID = item.ParticipantID.ToString();

                    vbebe.GroupNumber = item.GroupNumber.ToString();//drow[11].ToString();

                    vbebe.AccountNumber = item.AccountNumber.ToString();//drow[7].ToString();

                    vbebe.FileGenerationDateTime = FilegeneratedDateTime;

                    vbebe.Amount = item.Amount;//Convert.ToDouble(drow[12]);

                    vbebe.UserID = UserID;

                    vbebe.FileId = Convert.ToInt32(GeneratedFileId);

                    vbebo.InsertintoLuminXPaymentPostingDetails(vbebe);

                    TotalAmt += item.Amount;//Convert.ToDouble(drow[12]);

                    Recordcount++;

                    sb.AppendLine();            

                }               

                using (StreamWriter wtr = File.CreateText(FilePath))

                {

                    UpdateDtls();

                    wtr.Write(sb.ToString());                   

                    errMsg.Attributes["class"] = "MsgBox success";

                    errMsg.InnerHtml = "File generated successfully..";

                }

            }

            else

            {

                errMsg.Attributes["class"] = "MsgBox warning";

                errMsg.InnerHtml = " No records were found for given date range";               

                return;

            }

        }

        catch (Exception ex)

        {

            DeleteEntry();

            throw new Exception(ex.Message);

        }

    }

    protected void InsertintoLuminXPaymentPostingHeader()

    {

        try

        {

            // vbebe.FileName = fileName;      

            IEnumerable<ViewBankExceptionsBE> iegetfiletype;

            iegetfiletype = vbebo.GetExceptionsFileType();

            foreach (var ftype in iegetfiletype)

            {

                FilType = ftype.MasterData.ToString();

                ParentID = ftype.ParentFileID;

            }

            // FileFenerateDateTime =Convert.ToDateTime( fileDate);

            //FilePath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

            vbebe.FileName = strFileName;

            vbebe.FileType = FilType;

            FilegeneratedDateTime = gnl.GetASTDate(); // Convert.ToDateTime(ctx.fn_GetDaylightSavingsASTTime());

            vbebe.FileGenerationDateTime = FilegeneratedDateTime;

            string spath = ConfigurationManager.AppSettings["GenerateLetter"].ToString();

            string[] words = spath.Split('\\');

            string spath1 = words[0].ToString();

            string spath2 = words[1].ToString();

            string spath3 = words[2].ToString();

            //string Address1 = words[0].ToString();

            vbebe.FilePath = spath1 + "\\" + spath3;

            vbebe.ParentFileID = ParentID;

            vbebe.isActive = true;

            vbebe.UserID = UserID;

            vbebe.CreatedDateTime = gnl.GetASTDate();

            GeneratedFileId = vbebo.InsertintoLuminXPaymentPostingHeader(vbebe);

            vbebe.FileId = Convert.ToInt32(GeneratedFileId);

            errMsg.Attributes["class"] = "MsgBox success";

            errMsg.InnerHtml = rtnmsg;

        }

        catch (Exception ex)

        {

            //throw new Exception(ex.Message);

            errMsg.Attributes["class"] = "MsgBox error";

            errMsg.InnerHtml = ex.Message;

            return;

        }

    }

    public void UpdateDtls()

    {

        try

        {

            vbebe.Amount = TotalAmt;

            vbebe.TotalRecords = Recordcount;

            vbebe.FileId = Convert.ToInt32(GeneratedFileId);

            vbebe.FileGenerationEndDateTime = gnl.GetASTDate();

            vbebo.UpdateLuminXPaymentPostingHeader(vbebe);

        }

        catch (Exception ex)

        {

            throw ex;

        }

    }

    public void DeleteEntry()

    {

        try

        {

            vbebo.DeleteEntry(vbebe);

        }

        catch (Exception ex)

        {

            throw ex;

        }

    }

}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="BankExceptionManagement.aspx.cs"

    Inherits="UI_BankExceptionManagement" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Src="~/UserControls/HeaderControl.ascx" TagName="Header" TagPrefix="hdr" %>

<%@ Register Src="~/UserControls/FooterControl.ascx" TagName="Footer" TagPrefix="ftr" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <link rel="shortcut icon" href="../Images/favicon.ico" />

    <title>Bank Exception Management</title>

    <link href="~/Styles/Style.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript" src="../Scripts/jquery-1.4.1.min.js"></script>

    <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>

    <script language="javascript" type="text/javascript">

        /*  $(document).ready(function () {

        // This code is used to validate the search on search button click.

        //            $('[id$=chkSelectAll]').click(function () {

        //                $("[id$='chkSelect']").attr('checked', this.checked);

        //            });

        $("[id*=chkSelectAll]").live("click", function () {

        var chkHeader = $(this);

        var grid = $(this).closest("table");

        $("input[type=checkbox]", grid).each(function () {

        if (chkHeader.is(":checked")) {

        $(this).attr("checked", "checked");

        $("td", $(this).closest("tr")).addClass("selected");

        } else {

        $(this).removeAttr("checked");

        $("td", $(this).closest("tr")).removeClass("selected");

        }

        });

        });

        $("[id*=chkSelect]").live("click", function () {

        var grid = $(this).closest("table");

        var chkHeader = $("[id*=chkSelectAll]", grid);

        if (!$(this).is(":checked")) {

        $("td", $(this).closest("tr")).removeClass("selected");

        chkHeader.removeAttr("checked");

        } else {

        $("td", $(this).closest("tr")).addClass("selected");

        if ($("[id*=chkSelect]", grid).length == $("[id*=chkSelect]:checked", grid).length) {

        chkHeader.attr("checked", "checked");

        }

        }

        });

        });*/

        function Close() {

            var confrm = window.confirm("Are you sure, you want to close this window?");

            if (confrm == true) {

                return true;

            }

            else {

                return false;

            }

        }

    </script>

    <style type="text/css">

        .selected

        {

            background-color: #A1DCF2;

        }

    </style>

    <script type="text/javascript">

        $(document).ready(function () {

            $('#btnGenerateLetter').click(function () {

                document.getElementById("errMsg").style.visibility = "hidden";

                if ($("#ddlBankName").val() == '-Select-') {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("Select the BankName");

                    $('#ddlBankName').focus();

                    return false;

                }

                if ($("#ddlPholder").val() == '-Select-') {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  Select the policyholder");

                    $('#ddlPholder').focus();

                    return false;

                }

                var FromDate = $.trim($(".txtFromDate").val());

                if (FromDate.length == 0) {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  Enter Transaction From Date");

                    // $('#txtFromDate').focus();

                    return false;

                }

                // txtFromDate = document.getElementById('txtTranDate').value;

                var txtFromDate = $.trim($(".txtFromDate").val());

                var Datepattern = "^(0?[1-9]|1[012])[-/]?(0?[1-9]|[12][0-9]|3[01])[-/]?(19[\\d]{2}|20[\\d]{2}|2100)$";

                if (!txtFromDate.match(Datepattern)) {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  Enter Transaction from date in 'MM/dd/yy' format");

                    // $('#txtFromDate').focus();

                    return false;

                }

                var ToDate = $.trim($(".txtToDate").val());

                if (ToDate.length == 0) {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  Enter Transaction To Date");

                    //$('#txtToDate').focus();

                    return false;

                }

                var txtToDate = $.trim($(".txtToDate").val());

                if (!txtToDate.match(Datepattern)) {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  Enter Transaction To Date 'MM/dd/yy' Format");

                    // $('#txtFromDate').focus();

                    return false;

                }

                // var startDate = $('#txtFromDate').val().replace('/', '-');

                var startDate = $('#txtFromDate').val();

                var endDate = $('#txtToDate').val();

                date1 = new Date(startDate.split("/")[2], startDate.split("/")[0], startDate.split("/")[1]);

                date2 = new Date(endDate.split("/")[2], endDate.split("/")[0], endDate.split("/")[1]);

                if (date1 > date2) {

                    document.getElementById("errMsg").style.visibility = "visible";

                    document.getElementById("errMsg").className = "MsgBox warning";

                    $('#errMsg').html("  To Date Should be greater than From Date");

                    // $('#txtFromDate').focus();

                    return false;

                }

                ShowProgress();

                return true;

            });

            $('.ddlBankName').focusout(function () {

                //debugger;

                document.getElementById("errMsg").style.visibility = "hidden";

                // var value = $('.txtHidBankAccNo').val().length;

                //var BankName = $("#ddlBankName").get(0).selectedIndex;}

            });

            $('.ddlPholder').focusout(function () {

                //debugger;

                document.getElementById("errMsg").style.visibility = "hidden";

                // var value = $('.txtHidBankAccNo').val().length;

                //var BankName = $("#ddlBankName").get(0).selectedIndex;}

            });

            $('.txtFromDate').focusout(function () {

                //debugger;

                document.getElementById("errMsg").style.visibility = "hidden";

                var value = $('.txtFromDate').val().length;

            });

            $('.txtToDate').focusout(function () {

                document.getElementById("errMsg").style.visibility = "hidden";

                var value = $('.txtToDate').val().length;

            });

        });

    </script>

    <script type="text/javascript">

        function ClearFields() {

            //            document.getElementById("ddlBankName").options[0].selected = true;

            //            document.getElementById("txtFromDate").value = "";

            //            document.getElementById("txtToDate").value = "";

            //            document.getElementById("errMsg").style.visibility = "hidden";

            window.location.href = "BankExceptionManagement.aspx";

            return true;

        }

    </script>

    <script type="text/javascript">

        //This javascript function is used to display Loader when page is submitting to server

        function ShowProgress() {

            setTimeout(function () {

                var modal = $('<div />');

                modal.addClass("modal");

                $('body').append(modal);

                var loading = $(".loading");

                loading.show();

                var top = Math.max($(window).height() / 2 - loading[0].offsetHeight / 2, 0);

                var left = Math.max($(window).width() / 2 - loading[0].offsetWidth / 2, 0);

                loading.css({ top: top, left: left });

            }, 200);

        }      

    </script>

</head>

<body>

    <form id="form1" runat="server" defaultbutton="btnGenerateLetter">

    <div>

        <hdr:Header ID="headerMain" runat="server" />

        <center>

            <div id="content">

                <div class="content_section">

                    <table width="70%" border="0" style="border-color: Blue">

                        <tr>

                            <td align="center">

                                <asp:Label ID="lblUserMgmnt" runat="server" Text="Bank Exception Management"Font-Bold="True"

                                    Font-Size="Medium"></asp:Label>

                            </td>

                        </tr>

                        <tr>

                            <td align="center">

                                <%--<asp:Label ID="lblException" runat="server" ForeColor="Red"></asp:Label>--%>

                                <div id="errMsg" runat="server" style="width: 45%; height: auto">

                                </div>

                            </td>

                        </tr>

                        <tr>

                            <td align="center">

                                <table border="1" style="border-color: Blue" width="50%">

                                    <tr>

                                        <td>

                                            <table>

                                                <tr>

                                                    <td align="right">

                                                        <asp:Label ID="lblBankName" runat="server"Text="BankName"></asp:Label><span style="color: Red">*</span>

                                                    </td>

                                                    <td align="left">

                                                        <asp:DropDownList ID="ddlBankName" runat="server"Width="76%" CssClass="StyleDrpDown">

                                                            <asp:ListItem Text="BNTB" Value="BNTB"Selected="True"></asp:ListItem>

                                                            <%--<asp:ListItem Text="HSBC" Value="HSBC"></asp:ListItem>--%>

                                                            <%--<asp:ListItem Text="BNTB" Value="BNTB"></asp:ListItem>--%>

                                                            <%-- <asp:ListItem Text="Capital-G" Value="Capital-G"></asp:ListItem>--%>

                                                        </asp:DropDownList>

                                                    </td>

                                                </tr>

                                                <tr>

                                                    <td align="right">

                                                        <asp:Label ID="lblPholder" runat="server"Text="Policyholder"></asp:Label><span

                                                            style="color: Red">*</span>

                                                    </td>

                                                    <td align="left">

                                                        <asp:DropDownList ID="ddlPholder" runat="server"Width="76%" CssClass="StyleDrpDown">

                                                            <asp:ListItem Text="-Select-" Value="-Select-"Selected="True"></asp:ListItem>

                                                            <asp:ListItem Text="Group" Value="Group"></asp:ListItem>

                                                            <asp:ListItem Text="Individual"Value="Individual"></asp:ListItem>

                                                        </asp:DropDownList>

                                                    </td>

                                                </tr>

                                                <tr>

                                                    <td align="right">

                                                        <asp:Label ID="lblFromDate" runat="server"Text="Transaction from date"></asp:Label><span style="color: Red">*</span>

                                                    </td>

                                                    <td align="left">

                                                        <asp:TextBox ID="txtFromDate" CssClass="txtFromDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

                                                        <asp:CalendarExtender ID="CE3" runat="server"TargetControlID="txtFromDate" TodaysDateFormat="MMM dd, yyyy"

                                                            Enabled="True">

                                                        </asp:CalendarExtender>

                                                    </td>

                                                </tr>

                                                <tr>

                                                    <td align="right">

                                                        <asp:Label ID="lblToDate" runat="server"Text="Transaction to date"></asp:Label><span style="color: Red">*</span>

                                                    </td>

                                                    <td align="left">

                                                        <asp:TextBox ID="txtToDate" CssClass="txtToDate"runat="server" Width="75%" ReadOnly="false"></asp:TextBox>

                                                        <asp:CalendarExtender ID="CE4" runat="server"TargetControlID="txtToDate" TodaysDateFormat="MMM dd, yyyy"

                                                            Enabled="True">

                                                        </asp:CalendarExtender>

                                                    </td>

                                                </tr>

                                                <tr>

                                                    <td align="right">

                                                        <asp:Button ID="btnGenerateLetter"CssClass="btnGenerate" Text="Generate File" runat="server"

                                                            Width="105px" OnClick="btnGenerateLetter_Click"/>

                                                    </td>

                                                    <td align="left">

                                                        <input id="Reset1" type="reset" value="Reset"class="button" onclick="ClearFields()" />

                                                        <asp:Button ID="btnClose" Text="Close"CssClass="button" runat="server" Width="50px"

                                                            OnClick="btnClose_Click" />

                                                    </td>

                                                </tr>

                                            </table>

                                        </td>

                                    </tr>

                                </table>

                                <div class="loading" align="center">

                                    Generating...<br />

                                    <br />

                                    <br />

                                    <br />

                                    <img src="../Images/loader.gif" alt="" />

                                </div>

                            </td>

                        </tr>

                    </table>

                </div>

            </div>

        </center>

        <ftr:Footer ID="footermain" runat="server" />

    </div>

    </form>

</body>

</html>